
preserve
quietly {
	import excel "temp\adjust_benke_prior92.xlsx", firstrow clear
	rename (年龄 本科 专科)(age_group benke zhuanke)
	replace benke = subinstr(benke," ","",.)
	replace zhuanke = subinstr(zhuanke," ","",.)
	destring benke zhuanke, replace
	keep if inlist(age_group,"25-29岁","30-34岁","35-39岁","40-44岁","45-49岁","50-54岁")
	collapse (sum) benke zhuanke
	gen benkeshare = benke / ( benke + zhuanke )
}
dis benkeshare[1]